Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 43431 |
| Missing cells | 150388 |
| Missing cells (%) | 18.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.3 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Categorical | 7 |
from_date has a high cardinality: 20377 distinct values | High cardinality |
booking_created has a high cardinality: 39349 distinct values | High cardinality |
id is highly overall correlated with user_id and 1 other fields | High correlation |
user_id is highly overall correlated with id and 1 other fields | High correlation |
package_id is highly overall correlated with travel_type_id and 1 other fields | High correlation |
to_area_id is highly overall correlated with from_city_id | High correlation |
to_city_id is highly overall correlated with travel_type_id | High correlation |
to_date is highly overall correlated with id and 1 other fields | High correlation |
to_lat is highly overall correlated with from_city_id | High correlation |
to_long is highly overall correlated with from_city_id | High correlation |
travel_type_id is highly overall correlated with package_id and 1 other fields | High correlation |
from_city_id is highly overall correlated with package_id and 3 other fields | High correlation |
from_city_id is highly imbalanced (96.1%) | Imbalance |
mobile_site_booking is highly imbalanced (74.3%) | Imbalance |
Car_Cancellation is highly imbalanced (62.6%) | Imbalance |
package_id has 35881 (82.6%) missing values | Missing |
to_area_id has 9138 (21.0%) missing values | Missing |
from_city_id has 27086 (62.4%) missing values | Missing |
to_city_id has 41843 (96.3%) missing values | Missing |
to_date has 17890 (41.2%) missing values | Missing |
to_lat has 9138 (21.0%) missing values | Missing |
to_long has 9138 (21.0%) missing values | Missing |
to_date is highly skewed (γ1 = -50.22743775) | Skewed |
id is uniformly distributed | Uniform |
booking_created is uniformly distributed | Uniform |
id has unique values | Unique |
Reproduction
| Analysis started | 2023-04-13 17:40:41.046479 |
|---|---|
| Analysis finished | 2023-04-13 17:40:59.598416 |
| Duration | 18.55 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
id
Real number (ℝ)
HIGH CORRELATION UNIFORM UNIQUE
| Distinct | 43431 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 159206.47 |
| Minimum | 132512 |
|---|---|
| Maximum | 185941 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 132512 |
|---|---|
| 5-th percentile | 135140 |
| Q1 | 145778 |
| median | 159248 |
| Q3 | 172578.5 |
| 95-th percentile | 183262.5 |
| Maximum | 185941 |
| Range | 53429 |
| Interquartile range (IQR) | 26800.5 |
Descriptive statistics
| Standard deviation | 15442.386 |
|---|---|
| Coefficient of variation (CV) | 0.09699597 |
| Kurtosis | -1.2030119 |
| Mean | 159206.47 |
| Median Absolute Deviation (MAD) | 13400 |
| Skewness | -0.00065524227 |
| Sum | 6.9144964 × 109 |
| Variance | 2.3846729 × 108 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 132512 | 1 | < 0.1% |
| 168178 | 1 | < 0.1% |
| 168168 | 1 | < 0.1% |
| 168169 | 1 | < 0.1% |
| 168170 | 1 | < 0.1% |
| 168171 | 1 | < 0.1% |
| 168172 | 1 | < 0.1% |
| 168174 | 1 | < 0.1% |
| 168175 | 1 | < 0.1% |
| 168177 | 1 | < 0.1% |
| Other values (43421) | 43421 |
| Value | Count | Frequency (%) |
| 132512 | 1 | |
| 132513 | 1 | |
| 132514 | 1 | |
| 132515 | 1 | |
| 132517 | 1 | |
| 132518 | 1 | |
| 132519 | 1 | |
| 132520 | 1 | |
| 132521 | 1 | |
| 132522 | 1 |
| Value | Count | Frequency (%) |
| 185941 | 1 | |
| 185940 | 1 | |
| 185939 | 1 | |
| 185938 | 1 | |
| 185937 | 1 | |
| 185936 | 1 | |
| 185935 | 1 | |
| 185933 | 1 | |
| 185932 | 1 | |
| 185931 | 1 |
user_id
Real number (ℝ)
| Distinct | 22267 |
|---|---|
| Distinct (%) | 51.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 30739.198 |
| Minimum | 16 |
|---|---|
| Maximum | 48730 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 16 |
|---|---|
| 5-th percentile | 5969 |
| Q1 | 24614 |
| median | 31627 |
| Q3 | 39167 |
| 95-th percentile | 46185 |
| Maximum | 48730 |
| Range | 48714 |
| Interquartile range (IQR) | 14553 |
Descriptive statistics
| Standard deviation | 10996.477 |
|---|---|
| Coefficient of variation (CV) | 0.35773466 |
| Kurtosis | 0.40524291 |
| Mean | 30739.198 |
| Median Absolute Deviation (MAD) | 7265 |
| Skewness | -0.7458617 |
| Sum | 1.3350341 × 109 |
| Variance | 1.209225 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 29648 | 471 | 1.1% |
| 868 | 245 | 0.6% |
| 27458 | 211 | 0.5% |
| 32527 | 202 | 0.5% |
| 34972 | 198 | 0.5% |
| 33002 | 187 | 0.4% |
| 29275 | 185 | 0.4% |
| 32023 | 125 | 0.3% |
| 30290 | 120 | 0.3% |
| 38538 | 105 | 0.2% |
| Other values (22257) | 41382 |
| Value | Count | Frequency (%) |
| 16 | 3 | < 0.1% |
| 21 | 1 | < 0.1% |
| 24 | 1 | < 0.1% |
| 35 | 4 | < 0.1% |
| 36 | 1 | < 0.1% |
| 37 | 1 | < 0.1% |
| 39 | 1 | < 0.1% |
| 41 | 2 | < 0.1% |
| 42 | 10 | |
| 47 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 48730 | 1 | |
| 48729 | 1 | |
| 48727 | 1 | |
| 48726 | 1 | |
| 48725 | 1 | |
| 48724 | 1 | |
| 48723 | 1 | |
| 48721 | 1 | |
| 48719 | 1 | |
| 48718 | 1 |
vehicle_model_id
Real number (ℝ)
| Distinct | 27 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.71723 |
| Minimum | 1 |
|---|---|
| Maximum | 91 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 12 |
| median | 12 |
| Q3 | 24 |
| 95-th percentile | 89 |
| Maximum | 91 |
| Range | 90 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 26.79825 |
|---|---|
| Coefficient of variation (CV) | 1.0420349 |
| Kurtosis | 0.99161464 |
| Mean | 25.71723 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.6685277 |
| Sum | 1116925 |
| Variance | 718.14622 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=27)
| Value | Count | Frequency (%) |
| 12 | 31859 | |
| 85 | 2407 | 5.5% |
| 89 | 2391 | 5.5% |
| 65 | 1912 | 4.4% |
| 28 | 1702 | 3.9% |
| 24 | 1494 | 3.4% |
| 87 | 565 | 1.3% |
| 90 | 312 | 0.7% |
| 23 | 297 | 0.7% |
| 86 | 123 | 0.3% |
| Other values (17) | 369 | 0.8% |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 10 | 104 | 0.2% |
| 12 | 31859 | |
| 13 | 7 | < 0.1% |
| 14 | 1 | < 0.1% |
| 17 | 40 | 0.1% |
| 23 | 297 | 0.7% |
| 24 | 1494 | 3.4% |
| 28 | 1702 | 3.9% |
| 30 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 91 | 25 | 0.1% |
| 90 | 312 | 0.7% |
| 89 | 2391 | |
| 87 | 565 | 1.3% |
| 86 | 123 | 0.3% |
| 85 | 2407 | |
| 76 | 1 | < 0.1% |
| 75 | 1 | < 0.1% |
| 72 | 2 | < 0.1% |
| 70 | 1 | < 0.1% |
package_id
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 35881 |
| Missing (%) | 82.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.0300662 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.4617558 |
|---|---|
| Coefficient of variation (CV) | 0.72005326 |
| Kurtosis | 2.7266676 |
| Mean | 2.0300662 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.8508244 |
| Sum | 15327 |
| Variance | 2.13673 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 1 | 3503 | 8.1% |
| 2 | 2651 | 6.1% |
| 6 | 502 | 1.2% |
| 4 | 412 | 0.9% |
| 3 | 375 | 0.9% |
| 7 | 101 | 0.2% |
| 5 | 6 | < 0.1% |
| (Missing) | 35881 |
| Value | Count | Frequency (%) |
| 1 | 3503 | |
| 2 | 2651 | |
| 3 | 375 | 0.9% |
| 4 | 412 | 0.9% |
| 5 | 6 | < 0.1% |
| 6 | 502 | 1.2% |
| 7 | 101 | 0.2% |
| Value | Count | Frequency (%) |
| 7 | 101 | 0.2% |
| 6 | 502 | 1.2% |
| 5 | 6 | < 0.1% |
| 4 | 412 | 0.9% |
| 3 | 375 | 0.9% |
| 2 | 2651 | |
| 1 | 3503 |
travel_type_id
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.4 KiB |
| 2 | |
|---|---|
| 3 | |
| 1 | 1589 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 43431 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 2 |
| 3rd row | 2 |
| 4th row | 2 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 34292 | |
| 3 | 7550 | 17.4% |
| 1 | 1589 | 3.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 34292 | |
| 3 | 7550 | 17.4% |
| 1 | 1589 | 3.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 34292 | |
| 3 | 7550 | 17.4% |
| 1 | 1589 | 3.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 43431 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 34292 | |
| 3 | 7550 | 17.4% |
| 1 | 1589 | 3.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 43431 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 34292 | |
| 3 | 7550 | 17.4% |
| 1 | 1589 | 3.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43431 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 34292 | |
| 3 | 7550 | 17.4% |
| 1 | 1589 | 3.7% |
from_area_id
Real number (ℝ)
| Distinct | 598 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 88 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 714.54449 |
| Minimum | 2 |
|---|---|
| Maximum | 1403 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 89 |
| Q1 | 393 |
| median | 590 |
| Q3 | 1089 |
| 95-th percentile | 1365 |
| Maximum | 1403 |
| Range | 1401 |
| Interquartile range (IQR) | 696 |
Descriptive statistics
| Standard deviation | 419.88355 |
|---|---|
| Coefficient of variation (CV) | 0.58762408 |
| Kurtosis | -1.385828 |
| Mean | 714.54449 |
| Median Absolute Deviation (MAD) | 419 |
| Skewness | 0.095403298 |
| Sum | 30970502 |
| Variance | 176302.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 393 | 3858 | 8.9% |
| 571 | 1631 | 3.8% |
| 293 | 1052 | 2.4% |
| 585 | 911 | 2.1% |
| 1010 | 768 | 1.8% |
| 142 | 727 | 1.7% |
| 83 | 719 | 1.7% |
| 1384 | 628 | 1.4% |
| 1096 | 542 | 1.2% |
| 58 | 466 | 1.1% |
| Other values (588) | 32041 |
| Value | Count | Frequency (%) |
| 2 | 31 | 0.1% |
| 6 | 7 | < 0.1% |
| 15 | 6 | < 0.1% |
| 16 | 5 | < 0.1% |
| 17 | 2 | < 0.1% |
| 22 | 25 | 0.1% |
| 24 | 26 | 0.1% |
| 25 | 153 | |
| 34 | 33 | 0.1% |
| 49 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 1403 | 1 | < 0.1% |
| 1401 | 8 | < 0.1% |
| 1399 | 86 | |
| 1398 | 17 | < 0.1% |
| 1397 | 2 | < 0.1% |
| 1396 | 3 | < 0.1% |
| 1395 | 32 | 0.1% |
| 1394 | 9 | < 0.1% |
| 1393 | 37 | 0.1% |
| 1391 | 97 |
to_area_id
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 568 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 9138 |
| Missing (%) | 21.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 669.49092 |
| Minimum | 2 |
|---|---|
| Maximum | 1403 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 136 |
| Q1 | 393 |
| median | 541 |
| Q3 | 1054 |
| 95-th percentile | 1384 |
| Maximum | 1403 |
| Range | 1401 |
| Interquartile range (IQR) | 661 |
Descriptive statistics
| Standard deviation | 400.63823 |
|---|---|
| Coefficient of variation (CV) | 0.5984222 |
| Kurtosis | -1.1189618 |
| Mean | 669.49092 |
| Median Absolute Deviation (MAD) | 226 |
| Skewness | 0.49370455 |
| Sum | 22958852 |
| Variance | 160510.99 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 393 | 8777 | |
| 585 | 2339 | 5.4% |
| 1384 | 1237 | 2.8% |
| 571 | 664 | 1.5% |
| 293 | 555 | 1.3% |
| 1010 | 480 | 1.1% |
| 83 | 365 | 0.8% |
| 168 | 338 | 0.8% |
| 1371 | 332 | 0.8% |
| 452 | 330 | 0.8% |
| Other values (558) | 18876 | |
| (Missing) | 9138 |
| Value | Count | Frequency (%) |
| 2 | 4 | < 0.1% |
| 6 | 2 | < 0.1% |
| 15 | 5 | < 0.1% |
| 16 | 4 | < 0.1% |
| 17 | 1 | < 0.1% |
| 22 | 10 | < 0.1% |
| 24 | 7 | < 0.1% |
| 25 | 142 | |
| 34 | 15 | < 0.1% |
| 49 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 1403 | 1 | < 0.1% |
| 1401 | 2 | < 0.1% |
| 1399 | 74 | 0.2% |
| 1398 | 11 | < 0.1% |
| 1395 | 55 | 0.1% |
| 1394 | 8 | < 0.1% |
| 1393 | 185 | |
| 1391 | 37 | 0.1% |
| 1390 | 114 | |
| 1389 | 17 | < 0.1% |
from_city_id
Categorical
HIGH CORRELATION IMBALANCE MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 27086 |
| Missing (%) | 62.4% |
| Memory size | 339.4 KiB |
| 15.0 | |
|---|---|
| 1.0 | 106 |
| 31.0 | 6 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9935148 |
| Min length | 3 |
Characters and Unicode
| Total characters | 65274 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 15.0 |
|---|---|
| 2nd row | 15.0 |
| 3rd row | 1.0 |
| 4th row | 15.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 15.0 | 16233 | |
| 1.0 | 106 | 0.2% |
| 31.0 | 6 | < 0.1% |
| (Missing) | 27086 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 15.0 | 16233 | |
| 1.0 | 106 | 0.6% |
| 31.0 | 6 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 16345 | |
| . | 16345 | |
| 0 | 16345 | |
| 5 | 16233 | |
| 3 | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 48929 | |
| Other Punctuation | 16345 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 16345 | |
| 0 | 16345 | |
| 5 | 16233 | |
| 3 | 6 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 16345 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 65274 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 16345 | |
| . | 16345 | |
| 0 | 16345 | |
| 5 | 16233 | |
| 3 | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 65274 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 16345 | |
| . | 16345 | |
| 0 | 16345 | |
| 5 | 16233 | |
| 3 | 6 | < 0.1% |
to_city_id
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 116 |
|---|---|
| Distinct (%) | 7.3% |
| Missing | 41843 |
| Missing (%) | 96.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68.537783 |
| Minimum | 4 |
|---|---|
| Maximum | 203 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 32 |
| median | 49 |
| Q3 | 108 |
| 95-th percentile | 161.65 |
| Maximum | 203 |
| Range | 199 |
| Interquartile range (IQR) | 76 |
Descriptive statistics
| Standard deviation | 49.880732 |
|---|---|
| Coefficient of variation (CV) | 0.72778443 |
| Kurtosis | -0.29688118 |
| Mean | 68.537783 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 1.0276319 |
| Sum | 108838 |
| Variance | 2488.0874 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 32 | 475 | 1.1% |
| 55 | 174 | 0.4% |
| 29 | 116 | 0.3% |
| 146 | 89 | 0.2% |
| 108 | 64 | 0.1% |
| 41 | 27 | 0.1% |
| 58 | 26 | 0.1% |
| 147 | 26 | 0.1% |
| 131 | 26 | 0.1% |
| 44 | 26 | 0.1% |
| Other values (106) | 539 | 1.2% |
| (Missing) | 41843 |
| Value | Count | Frequency (%) |
| 4 | 11 | |
| 5 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 3 | < 0.1% |
| 11 | 2 | < 0.1% |
| 12 | 6 | < 0.1% |
| 13 | 21 | |
| 14 | 5 | < 0.1% |
| 16 | 1 | < 0.1% |
| 17 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 203 | 4 | < 0.1% |
| 200 | 1 | < 0.1% |
| 198 | 5 | |
| 197 | 1 | < 0.1% |
| 196 | 1 | < 0.1% |
| 192 | 5 | |
| 191 | 12 | |
| 190 | 8 | |
| 189 | 4 | < 0.1% |
| 187 | 1 | < 0.1% |
from_date
Categorical
| Distinct | 20377 |
|---|---|
| Distinct (%) | 46.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.4 KiB |
| 10/12/2013 6:00 | 20 |
|---|---|
| 7/4/2013 22:15 | 20 |
| 9/8/2013 6:00 | 16 |
| 5/12/2013 7:30 | 15 |
| 9/16/2013 8:00 | 13 |
| Other values (20372) |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 14.477562 |
| Min length | 13 |
Characters and Unicode
| Total characters | 628775 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9095 ? |
|---|---|
| Unique (%) | 20.9% |
Sample
| 1st row | 1/1/2013 2:00 |
|---|---|
| 2nd row | 1/1/2013 9:00 |
| 3rd row | 1/1/2013 3:30 |
| 4th row | 1/1/2013 5:45 |
| 5th row | 1/1/2013 9:00 |
Common Values
| Value | Count | Frequency (%) |
| 10/12/2013 6:00 | 20 | < 0.1% |
| 7/4/2013 22:15 | 20 | < 0.1% |
| 9/8/2013 6:00 | 16 | < 0.1% |
| 5/12/2013 7:30 | 15 | < 0.1% |
| 9/16/2013 8:00 | 13 | < 0.1% |
| 5/12/2013 7:00 | 13 | < 0.1% |
| 5/19/2013 5:00 | 13 | < 0.1% |
| 9/5/2013 9:30 | 12 | < 0.1% |
| 10/9/2013 9:00 | 12 | < 0.1% |
| 9/2/2013 9:30 | 12 | < 0.1% |
| Other values (20367) | 43285 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 8:00 | 1150 | 1.3% |
| 9:00 | 1123 | 1.3% |
| 6:00 | 1078 | 1.2% |
| 18:00 | 1023 | 1.2% |
| 10:00 | 996 | 1.1% |
| 9:30 | 994 | 1.1% |
| 17:00 | 985 | 1.1% |
| 8:30 | 920 | 1.1% |
| 7:00 | 891 | 1.0% |
| 7:30 | 848 | 1.0% |
| Other values (433) | 76854 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 107437 | |
| 0 | 104488 | |
| / | 86862 | |
| 2 | 74076 | |
| 3 | 71016 | |
| 43431 | ||
| : | 43431 | |
| 5 | 24748 | 3.9% |
| 4 | 17204 | 2.7% |
| 8 | 15212 | 2.4% |
| Other values (3) | 40870 | 6.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 455051 | |
| Other Punctuation | 130293 | 20.7% |
| Space Separator | 43431 | 6.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 107437 | |
| 0 | 104488 | |
| 2 | 74076 | |
| 3 | 71016 | |
| 5 | 24748 | 5.4% |
| 4 | 17204 | 3.8% |
| 8 | 15212 | 3.3% |
| 7 | 14233 | 3.1% |
| 9 | 13896 | 3.1% |
| 6 | 12741 | 2.8% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 86862 | |
| : | 43431 |
Space Separator
| Value | Count | Frequency (%) |
| 43431 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 628775 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 107437 | |
| 0 | 104488 | |
| / | 86862 | |
| 2 | 74076 | |
| 3 | 71016 | |
| 43431 | ||
| : | 43431 | |
| 5 | 24748 | 3.9% |
| 4 | 17204 | 2.7% |
| 8 | 15212 | 2.4% |
| Other values (3) | 40870 | 6.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 628775 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 107437 | |
| 0 | 104488 | |
| / | 86862 | |
| 2 | 74076 | |
| 3 | 71016 | |
| 43431 | ||
| : | 43431 | |
| 5 | 24748 | 3.9% |
| 4 | 17204 | 2.7% |
| 8 | 15212 | 2.4% |
| Other values (3) | 40870 | 6.5% |
to_date
Real number (ℝ)
HIGH CORRELATION MISSING SKEWED
| Distinct | 22151 |
|---|---|
| Distinct (%) | 86.7% |
| Missing | 17890 |
| Missing (%) | 41.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41507.975 |
| Minimum | 25569.021 |
|---|---|
| Maximum | 41678.276 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 25569.021 |
|---|---|
| 5-th percentile | 41403 |
| Q1 | 41480.521 |
| median | 41517.762 |
| Q3 | 41558.915 |
| 95-th percentile | 41594.225 |
| Maximum | 41678.276 |
| Range | 16109.255 |
| Interquartile range (IQR) | 78.39352 |
Descriptive statistics
| Standard deviation | 305.14494 |
|---|---|
| Coefficient of variation (CV) | 0.0073514775 |
| Kurtosis | 2620.6252 |
| Mean | 41507.975 |
| Median Absolute Deviation (MAD) | 39.432 |
| Skewness | -50.227438 |
| Sum | 1.0601552 × 109 |
| Variance | 93113.437 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 41427 | 38 | 0.1% |
| 41406 | 34 | 0.1% |
| 41434 | 34 | 0.1% |
| 41420 | 32 | 0.1% |
| 41426 | 31 | 0.1% |
| 41413 | 29 | 0.1% |
| 41433 | 26 | 0.1% |
| 41447 | 25 | 0.1% |
| 41405 | 24 | 0.1% |
| 41440 | 24 | 0.1% |
| Other values (22141) | 25244 | |
| (Missing) | 17890 |
| Value | Count | Frequency (%) |
| 25569.02083 | 2 | |
| 25569.22917 | 1 | |
| 25569.29167 | 1 | |
| 25569.375 | 1 | |
| 25569.38542 | 1 | |
| 25569.41667 | 1 | |
| 25569.66667 | 1 | |
| 25569.875 | 1 | |
| 41275 | 1 | |
| 41275.40625 | 1 |
| Value | Count | Frequency (%) |
| 41678.27568 | 1 | |
| 41677.63016 | 1 | |
| 41638 | 1 | |
| 41634.99931 | 1 | |
| 41623.38366 | 1 | |
| 41623.24115 | 1 | |
| 41619.97228 | 1 | |
| 41619.01017 | 1 | |
| 41618.93374 | 1 | |
| 41618.21785 | 1 |
online_booking
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.4 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 43431 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 28161 | |
| 1 | 15270 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 28161 | |
| 1 | 15270 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 28161 | |
| 1 | 15270 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 43431 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 28161 | |
| 1 | 15270 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 43431 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 28161 | |
| 1 | 15270 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43431 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 28161 | |
| 1 | 15270 |
mobile_site_booking
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.4 KiB |
| 0 | |
|---|---|
| 1 | 1878 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 43431 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 41553 | |
| 1 | 1878 | 4.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 41553 | |
| 1 | 1878 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 41553 | |
| 1 | 1878 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 43431 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 41553 | |
| 1 | 1878 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 43431 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 41553 | |
| 1 | 1878 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43431 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 41553 | |
| 1 | 1878 | 4.3% |
booking_created
Categorical
HIGH CARDINALITY UNIFORM
| Distinct | 39349 |
|---|---|
| Distinct (%) | 90.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.4 KiB |
| 10/31/2013 10:30 | 18 |
|---|---|
| 10/31/2013 9:58 | 17 |
| 10/3/2013 14:13 | 16 |
| 8/1/2013 7:24 | 15 |
| 8/31/2013 9:51 | 14 |
| Other values (39344) |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 14.701296 |
| Min length | 13 |
Characters and Unicode
| Total characters | 638492 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 36714 ? |
|---|---|
| Unique (%) | 84.5% |
Sample
| 1st row | 1/1/2013 1:39 |
|---|---|
| 2nd row | 1/1/2013 2:25 |
| 3rd row | 1/1/2013 3:08 |
| 4th row | 1/1/2013 4:39 |
| 5th row | 1/1/2013 7:53 |
Common Values
| Value | Count | Frequency (%) |
| 10/31/2013 10:30 | 18 | < 0.1% |
| 10/31/2013 9:58 | 17 | < 0.1% |
| 10/3/2013 14:13 | 16 | < 0.1% |
| 8/1/2013 7:24 | 15 | < 0.1% |
| 8/31/2013 9:51 | 14 | < 0.1% |
| 10/31/2013 12:17 | 13 | < 0.1% |
| 8/1/2013 13:47 | 13 | < 0.1% |
| 8/30/2013 17:54 | 13 | < 0.1% |
| 10/31/2013 12:24 | 13 | < 0.1% |
| 10/31/2013 9:43 | 13 | < 0.1% |
| Other values (39339) | 43286 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 10/31/2013 | 515 | 0.6% |
| 8/30/2013 | 363 | 0.4% |
| 7/6/2013 | 339 | 0.4% |
| 9/27/2013 | 305 | 0.4% |
| 8/1/2013 | 287 | 0.3% |
| 8/31/2013 | 249 | 0.3% |
| 6/1/2013 | 244 | 0.3% |
| 8/2/2013 | 238 | 0.3% |
| 9/30/2013 | 236 | 0.3% |
| 7/12/2013 | 228 | 0.3% |
| Other values (1733) | 83858 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 121028 | |
| 2 | 89831 | |
| / | 86862 | |
| 0 | 70987 | |
| 3 | 69371 | |
| 43431 | 6.8% | |
| : | 43431 | 6.8% |
| 5 | 22577 | 3.5% |
| 4 | 21439 | 3.4% |
| 9 | 18291 | 2.9% |
| Other values (3) | 51244 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 464768 | |
| Other Punctuation | 130293 | 20.4% |
| Space Separator | 43431 | 6.8% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 121028 | |
| 2 | 89831 | |
| 0 | 70987 | |
| 3 | 69371 | |
| 5 | 22577 | 4.9% |
| 4 | 21439 | 4.6% |
| 9 | 18291 | 3.9% |
| 8 | 18178 | 3.9% |
| 7 | 17237 | 3.7% |
| 6 | 15829 | 3.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 86862 | |
| : | 43431 |
Space Separator
| Value | Count | Frequency (%) |
| 43431 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 638492 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 121028 | |
| 2 | 89831 | |
| / | 86862 | |
| 0 | 70987 | |
| 3 | 69371 | |
| 43431 | 6.8% | |
| : | 43431 | 6.8% |
| 5 | 22577 | 3.5% |
| 4 | 21439 | 3.4% |
| 9 | 18291 | 2.9% |
| Other values (3) | 51244 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 638492 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 121028 | |
| 2 | 89831 | |
| / | 86862 | |
| 0 | 70987 | |
| 3 | 69371 | |
| 43431 | 6.8% | |
| : | 43431 | 6.8% |
| 5 | 22577 | 3.5% |
| 4 | 21439 | 3.4% |
| 9 | 18291 | 2.9% |
| Other values (3) | 51244 |
from_lat
Real number (ℝ)
| Distinct | 466 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 93 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.982461 |
| Minimum | 12.77663 |
|---|---|
| Maximum | 13.366072 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 12.77663 |
|---|---|
| 5-th percentile | 12.869805 |
| Q1 | 12.92645 |
| median | 12.968887 |
| Q3 | 13.00775 |
| 95-th percentile | 13.19956 |
| Maximum | 13.366072 |
| Range | 0.589442 |
| Interquartile range (IQR) | 0.0813 |
Descriptive statistics
| Standard deviation | 0.085932527 |
|---|---|
| Coefficient of variation (CV) | 0.0066191247 |
| Kurtosis | 1.3719346 |
| Mean | 12.982461 |
| Median Absolute Deviation (MAD) | 0.041207 |
| Skewness | 1.2104129 |
| Sum | 562633.89 |
| Variance | 0.0073843992 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13.19956 | 3858 | 8.9% |
| 12.95185 | 1631 | 3.8% |
| 12.97677 | 1080 | 2.5% |
| 12.849482 | 1052 | 2.4% |
| 12.92415 | 960 | 2.2% |
| 13.02853 | 928 | 2.1% |
| 12.96691 | 776 | 1.8% |
| 12.91281 | 732 | 1.7% |
| 12.96519 | 726 | 1.7% |
| 12.9744 | 468 | 1.1% |
| Other values (456) | 31127 |
| Value | Count | Frequency (%) |
| 12.77663 | 13 | < 0.1% |
| 12.78091 | 12 | < 0.1% |
| 12.78665 | 11 | < 0.1% |
| 12.79665 | 10 | < 0.1% |
| 12.80257 | 26 | 0.1% |
| 12.81575 | 124 | |
| 12.824606 | 3 | < 0.1% |
| 12.827912 | 28 | 0.1% |
| 12.832201 | 4 | < 0.1% |
| 12.833854 | 20 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.366072 | 5 | < 0.1% |
| 13.24373 | 22 | 0.1% |
| 13.206811 | 9 | < 0.1% |
| 13.19966 | 37 | 0.1% |
| 13.19956 | 3858 | |
| 13.175103 | 1 | < 0.1% |
| 13.17256 | 1 | < 0.1% |
| 13.13785 | 40 | 0.1% |
| 13.13243 | 17 | < 0.1% |
| 13.13128 | 1 | < 0.1% |
from_long
Real number (ℝ)
| Distinct | 462 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 93 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.636255 |
| Minimum | 77.38693 |
|---|---|
| Maximum | 77.78642 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 77.38693 |
|---|---|
| 5-th percentile | 77.54481 |
| Q1 | 77.593661 |
| median | 77.63575 |
| Q3 | 77.6889 |
| 95-th percentile | 77.71932 |
| Maximum | 77.78642 |
| Range | 0.39949 |
| Interquartile range (IQR) | 0.095239 |
Descriptive statistics
| Standard deviation | 0.059390976 |
|---|---|
| Coefficient of variation (CV) | 0.00076499023 |
| Kurtosis | -0.60829059 |
| Mean | 77.636255 |
| Median Absolute Deviation (MAD) | 0.046623 |
| Skewness | -0.15391031 |
| Sum | 3364600 |
| Variance | 0.003527288 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 77.70688 | 3895 | 9.0% |
| 77.69642 | 1631 | 3.8% |
| 77.5727 | 1080 | 2.5% |
| 77.663187 | 1052 | 2.4% |
| 77.67229 | 960 | 2.2% |
| 77.54625 | 928 | 2.1% |
| 77.74935 | 776 | 1.8% |
| 77.60923 | 732 | 1.7% |
| 77.71932 | 726 | 1.7% |
| 77.69183 | 468 | 1.1% |
| Other values (452) | 31090 |
| Value | Count | Frequency (%) |
| 77.38693 | 10 | < 0.1% |
| 77.38845 | 7 | < 0.1% |
| 77.400913 | 20 | |
| 77.442232 | 5 | < 0.1% |
| 77.45876 | 2 | < 0.1% |
| 77.461074 | 2 | < 0.1% |
| 77.473672 | 33 | |
| 77.474893 | 1 | < 0.1% |
| 77.47725 | 40 | |
| 77.480214 | 30 |
| Value | Count | Frequency (%) |
| 77.78642 | 30 | 0.1% |
| 77.77131 | 12 | < 0.1% |
| 77.761764 | 12 | < 0.1% |
| 77.750528 | 47 | 0.1% |
| 77.74935 | 776 | |
| 77.747099 | 135 | 0.3% |
| 77.74657 | 69 | 0.2% |
| 77.737731 | 9 | < 0.1% |
| 77.736123 | 18 | < 0.1% |
| 77.735245 | 242 | 0.6% |
to_lat
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 450 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 9138 |
| Missing (%) | 21.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.026648 |
| Minimum | 12.77663 |
|---|---|
| Maximum | 13.366072 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 12.77663 |
|---|---|
| 5-th percentile | 12.88963 |
| Q1 | 12.95185 |
| median | 12.98275 |
| Q3 | 13.19956 |
| 95-th percentile | 13.19956 |
| Maximum | 13.366072 |
| Range | 0.589442 |
| Interquartile range (IQR) | 0.24771 |
Descriptive statistics
| Standard deviation | 0.11348743 |
|---|---|
| Coefficient of variation (CV) | 0.0087119438 |
| Kurtosis | -1.032068 |
| Mean | 13.026648 |
| Median Absolute Deviation (MAD) | 0.05253 |
| Skewness | 0.54453592 |
| Sum | 446722.86 |
| Variance | 0.012879397 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13.19956 | 8777 | |
| 12.97677 | 2573 | 5.9% |
| 13.02853 | 1531 | 3.5% |
| 12.95185 | 664 | 1.5% |
| 12.849482 | 555 | 1.3% |
| 12.96691 | 484 | 1.1% |
| 12.92415 | 447 | 1.0% |
| 12.91873 | 377 | 0.9% |
| 12.99313 | 338 | 0.8% |
| 13.000418 | 332 | 0.8% |
| Other values (440) | 18215 | |
| (Missing) | 9138 |
| Value | Count | Frequency (%) |
| 12.77663 | 17 | < 0.1% |
| 12.78091 | 5 | < 0.1% |
| 12.78665 | 12 | < 0.1% |
| 12.79665 | 4 | < 0.1% |
| 12.80257 | 27 | 0.1% |
| 12.81575 | 147 | |
| 12.824606 | 1 | < 0.1% |
| 12.827912 | 11 | < 0.1% |
| 12.832201 | 5 | < 0.1% |
| 12.833854 | 18 | < 0.1% |
| Value | Count | Frequency (%) |
| 13.366072 | 16 | < 0.1% |
| 13.24373 | 25 | 0.1% |
| 13.206811 | 3 | < 0.1% |
| 13.19966 | 185 | 0.4% |
| 13.19956 | 8777 | |
| 13.175103 | 1 | < 0.1% |
| 13.17318 | 1 | < 0.1% |
| 13.17256 | 2 | < 0.1% |
| 13.13785 | 24 | 0.1% |
| 13.13243 | 12 | < 0.1% |
to_long
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 447 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 9138 |
| Missing (%) | 21.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 77.640595 |
| Minimum | 77.38693 |
|---|---|
| Maximum | 77.78642 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 339.4 KiB |
Quantile statistics
| Minimum | 77.38693 |
|---|---|
| 5-th percentile | 77.54625 |
| Q1 | 77.58203 |
| median | 77.64503 |
| Q3 | 77.70688 |
| 95-th percentile | 77.71662 |
| Maximum | 77.78642 |
| Range | 0.39949 |
| Interquartile range (IQR) | 0.12485 |
Descriptive statistics
| Standard deviation | 0.064045299 |
|---|---|
| Coefficient of variation (CV) | 0.00082489448 |
| Kurtosis | -1.0068015 |
| Mean | 77.640595 |
| Median Absolute Deviation (MAD) | 0.06185 |
| Skewness | -0.26540506 |
| Sum | 2662528.9 |
| Variance | 0.0041018003 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 77.70688 | 8962 | |
| 77.5727 | 2573 | 5.9% |
| 77.54625 | 1531 | 3.5% |
| 77.69642 | 664 | 1.5% |
| 77.663187 | 555 | 1.3% |
| 77.74935 | 484 | 1.1% |
| 77.67229 | 447 | 1.0% |
| 77.61494 | 377 | 0.9% |
| 77.59828 | 338 | 0.8% |
| 77.674835 | 332 | 0.8% |
| Other values (437) | 18030 | |
| (Missing) | 9138 |
| Value | Count | Frequency (%) |
| 77.38693 | 4 | < 0.1% |
| 77.38845 | 7 | < 0.1% |
| 77.400913 | 18 | < 0.1% |
| 77.442232 | 10 | < 0.1% |
| 77.45876 | 2 | < 0.1% |
| 77.461074 | 2 | < 0.1% |
| 77.473672 | 52 | |
| 77.47725 | 24 | 0.1% |
| 77.480214 | 28 | 0.1% |
| 77.48279 | 82 |
| Value | Count | Frequency (%) |
| 77.78642 | 19 | < 0.1% |
| 77.77131 | 5 | < 0.1% |
| 77.761764 | 18 | < 0.1% |
| 77.750528 | 34 | 0.1% |
| 77.74935 | 484 | |
| 77.747099 | 47 | 0.1% |
| 77.74657 | 19 | < 0.1% |
| 77.74481 | 51 | 0.1% |
| 77.737731 | 3 | < 0.1% |
| 77.736123 | 6 | < 0.1% |
Car_Cancellation
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 339.4 KiB |
| 0 | |
|---|---|
| 1 | 3132 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 43431 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 40299 | |
| 1 | 3132 | 7.2% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 40299 | |
| 1 | 3132 | 7.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 40299 | |
| 1 | 3132 | 7.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 43431 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 40299 | |
| 1 | 3132 | 7.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 43431 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 40299 | |
| 1 | 3132 | 7.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 43431 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 40299 | |
| 1 | 3132 | 7.2% |
| id | user_id | vehicle_model_id | package_id | from_area_id | to_area_id | to_city_id | to_date | from_lat | from_long | to_lat | to_long | travel_type_id | from_city_id | online_booking | mobile_site_booking | Car_Cancellation | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | 1.000 | 0.686 | 0.036 | 0.328 | 0.023 | 0.025 | -0.027 | 0.995 | 0.036 | 0.032 | 0.027 | 0.031 | 0.035 | 0.248 | 0.126 | 0.100 | 0.215 |
| user_id | 0.686 | 1.000 | 0.059 | 0.225 | 0.019 | 0.011 | -0.038 | 0.558 | 0.041 | 0.010 | 0.049 | 0.039 | 0.054 | 0.075 | 0.131 | 0.066 | 0.149 |
| vehicle_model_id | 0.036 | 0.059 | 1.000 | 0.160 | -0.023 | -0.043 | 0.003 | 0.017 | 0.051 | 0.022 | 0.053 | 0.061 | 0.218 | 0.094 | 0.023 | 0.023 | 0.080 |
| package_id | 0.328 | 0.225 | 0.160 | 1.000 | -0.000 | NaN | NaN | 0.347 | -0.013 | 0.030 | NaN | NaN | 1.000 | 1.000 | 0.132 | 0.059 | 0.126 |
| from_area_id | 0.023 | 0.019 | -0.023 | -0.000 | 1.000 | 0.012 | 0.020 | -0.002 | -0.003 | -0.111 | 0.002 | 0.007 | 0.052 | 0.033 | 0.089 | 0.037 | 0.046 |
| to_area_id | 0.025 | 0.011 | -0.043 | NaN | 0.012 | 1.000 | NaN | 0.001 | 0.017 | 0.020 | -0.159 | -0.330 | 0.000 | 1.000 | 0.115 | 0.032 | 0.137 |
| to_city_id | -0.027 | -0.038 | 0.003 | NaN | 0.020 | NaN | 1.000 | -0.035 | -0.011 | -0.002 | NaN | NaN | 1.000 | 0.080 | 0.000 | 0.097 | 0.000 |
| to_date | 0.995 | 0.558 | 0.017 | 0.347 | -0.002 | 0.001 | -0.035 | 1.000 | 0.030 | 0.009 | 0.004 | 0.013 | 0.075 | 0.195 | 0.010 | 0.000 | 0.000 |
| from_lat | 0.036 | 0.041 | 0.051 | -0.013 | -0.003 | 0.017 | -0.011 | 0.030 | 1.000 | 0.110 | -0.122 | -0.033 | 0.089 | 0.041 | 0.088 | 0.052 | 0.083 |
| from_long | 0.032 | 0.010 | 0.022 | 0.030 | -0.111 | 0.020 | -0.002 | 0.009 | 0.110 | 1.000 | -0.057 | 0.028 | 0.070 | 0.027 | 0.103 | 0.031 | 0.088 |
| to_lat | 0.027 | 0.049 | 0.053 | NaN | 0.002 | -0.159 | NaN | 0.004 | -0.122 | -0.057 | 1.000 | 0.407 | 0.000 | 1.000 | 0.098 | 0.015 | 0.147 |
| to_long | 0.031 | 0.039 | 0.061 | NaN | 0.007 | -0.330 | NaN | 0.013 | -0.033 | 0.028 | 0.407 | 1.000 | 0.000 | 1.000 | 0.089 | 0.008 | 0.136 |
| travel_type_id | 0.035 | 0.054 | 0.218 | 1.000 | 0.052 | 0.000 | 1.000 | 0.075 | 0.089 | 0.070 | 0.000 | 0.000 | 1.000 | 0.192 | 0.070 | 0.046 | 0.069 |
| from_city_id | 0.248 | 0.075 | 0.094 | 1.000 | 0.033 | 1.000 | 0.080 | 0.195 | 0.041 | 0.027 | 1.000 | 1.000 | 0.192 | 1.000 | 0.088 | 0.020 | 0.026 |
| online_booking | 0.126 | 0.131 | 0.023 | 0.132 | 0.089 | 0.115 | 0.000 | 0.010 | 0.088 | 0.103 | 0.098 | 0.089 | 0.070 | 0.088 | 1.000 | 0.156 | 0.149 |
| mobile_site_booking | 0.100 | 0.066 | 0.023 | 0.059 | 0.037 | 0.032 | 0.097 | 0.000 | 0.052 | 0.031 | 0.015 | 0.008 | 0.046 | 0.020 | 0.156 | 1.000 | 0.067 |
| Car_Cancellation | 0.215 | 0.149 | 0.080 | 0.126 | 0.046 | 0.137 | 0.000 | 0.000 | 0.083 | 0.088 | 0.147 | 0.136 | 0.069 | 0.026 | 0.149 | 0.067 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| id | user_id | vehicle_model_id | package_id | travel_type_id | from_area_id | to_area_id | from_city_id | to_city_id | from_date | to_date | online_booking | mobile_site_booking | booking_created | from_lat | from_long | to_lat | to_long | Car_Cancellation | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 132512 | 22177 | 28 | NaN | 2 | 83.0 | 448.0 | NaN | NaN | 1/1/2013 2:00 | NaN | 0 | 0 | 1/1/2013 1:39 | 12.924150 | 77.672290 | 12.927320 | 77.635750 | 0 |
| 1 | 132513 | 21413 | 12 | NaN | 2 | 1010.0 | 540.0 | NaN | NaN | 1/1/2013 9:00 | NaN | 0 | 0 | 1/1/2013 2:25 | 12.966910 | 77.749350 | 12.927680 | 77.626640 | 0 |
| 2 | 132514 | 22178 | 12 | NaN | 2 | 1301.0 | 1034.0 | NaN | NaN | 1/1/2013 3:30 | NaN | 0 | 0 | 1/1/2013 3:08 | 12.937222 | 77.626915 | 13.047926 | 77.597766 | 0 |
| 3 | 132515 | 13034 | 12 | NaN | 2 | 768.0 | 398.0 | NaN | NaN | 1/1/2013 5:45 | NaN | 0 | 0 | 1/1/2013 4:39 | 12.989990 | 77.553320 | 12.971430 | 77.639140 | 0 |
| 4 | 132517 | 22180 | 12 | NaN | 2 | 1365.0 | 849.0 | NaN | NaN | 1/1/2013 9:00 | NaN | 0 | 0 | 1/1/2013 7:53 | 12.845653 | 77.677925 | 12.954340 | 77.600720 | 0 |
| 5 | 132518 | 17712 | 12 | NaN | 2 | 1021.0 | 1323.0 | NaN | NaN | 1/1/2013 22:30 | NaN | 0 | 0 | 1/1/2013 8:01 | 13.028530 | 77.546250 | 12.869805 | 77.653211 | 0 |
| 6 | 132519 | 22172 | 12 | NaN | 1 | 571.0 | NaN | 15.0 | 108.0 | 1/1/2013 9:45 | 41275.40625 | 0 | 0 | 1/1/2013 9:21 | 12.951850 | 77.696420 | NaN | NaN | 0 |
| 7 | 132520 | 22181 | 12 | NaN | 2 | 1192.0 | 832.0 | NaN | NaN | 1/1/2013 11:00 | NaN | 0 | 0 | 1/1/2013 9:39 | 12.976770 | 77.572700 | 12.880190 | 77.645580 | 0 |
| 8 | 132521 | 22182 | 65 | 2.0 | 3 | 448.0 | NaN | NaN | NaN | 1/1/2013 16:00 | NaN | 0 | 0 | 1/1/2013 9:44 | 12.927320 | 77.635750 | NaN | NaN | 0 |
| 9 | 132522 | 22184 | 12 | NaN | 2 | 516.0 | 376.0 | NaN | NaN | 1/1/2013 11:00 | NaN | 0 | 0 | 1/1/2013 9:49 | 13.005600 | 77.657990 | 12.902450 | 77.660810 | 0 |
| id | user_id | vehicle_model_id | package_id | travel_type_id | from_area_id | to_area_id | from_city_id | to_city_id | from_date | to_date | online_booking | mobile_site_booking | booking_created | from_lat | from_long | to_lat | to_long | Car_Cancellation | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43421 | 185931 | 48723 | 12 | NaN | 2 | 1371.0 | 1181.0 | 15.0 | NaN | 11/25/2013 9:45 | 41603.43118 | 0 | 0 | 11/24/2013 14:10 | 13.000418 | 77.674835 | 12.978960 | 77.67345 | 0 |
| 43422 | 185932 | 48724 | 12 | NaN | 2 | 393.0 | 269.0 | 15.0 | NaN | 11/24/2013 21:15 | 41602.98345 | 0 | 0 | 11/24/2013 14:12 | 13.199560 | 77.706880 | 12.974400 | 77.69183 | 1 |
| 43423 | 185933 | 48725 | 24 | NaN | 2 | 585.0 | 339.0 | 15.0 | NaN | 11/24/2013 16:00 | 41602.70913 | 0 | 1 | 11/24/2013 14:15 | 12.976770 | 77.572700 | 12.910280 | 77.64512 | 0 |
| 43424 | 185935 | 48726 | 12 | 2.0 | 3 | 515.0 | NaN | 15.0 | NaN | 11/24/2013 15:15 | 41603.01042 | 0 | 0 | 11/24/2013 14:23 | 12.978960 | 77.673450 | NaN | NaN | 0 |
| 43425 | 185936 | 30220 | 12 | NaN | 2 | 585.0 | 1226.0 | 15.0 | NaN | 11/25/2013 0:00 | 41603.03336 | 0 | 1 | 11/24/2013 14:24 | 12.976770 | 77.572700 | 13.015080 | 77.67796 | 0 |
| 43426 | 185937 | 14364 | 12 | NaN | 2 | 1147.0 | 452.0 | 15.0 | NaN | 11/24/2013 18:00 | 41602.82020 | 1 | 0 | 11/24/2013 14:25 | 13.030640 | 77.649100 | 12.952780 | 77.59088 | 0 |
| 43427 | 185938 | 48727 | 12 | NaN | 2 | 393.0 | 466.0 | 15.0 | NaN | 11/26/2013 1:00 | 41604.08037 | 1 | 0 | 11/24/2013 14:30 | 13.199560 | 77.706880 | 13.017436 | 77.64458 | 0 |
| 43428 | 185939 | 48729 | 12 | 1.0 | 3 | 974.0 | NaN | 15.0 | NaN | 11/24/2013 18:30 | 41602.97917 | 0 | 0 | 11/24/2013 14:35 | 13.075570 | 77.559040 | NaN | NaN | 0 |
| 43429 | 185940 | 30724 | 87 | NaN | 2 | 1263.0 | 542.0 | 15.0 | NaN | 11/24/2013 16:00 | 41602.69495 | 0 | 0 | 11/24/2013 14:43 | 12.968970 | 77.594560 | 12.938230 | 77.62289 | 0 |
| 43430 | 185941 | 48730 | 12 | NaN | 2 | 689.0 | 393.0 | 15.0 | NaN | 11/25/2013 5:00 | 41603.25385 | 0 | 1 | 11/24/2013 14:50 | 12.976720 | 77.649270 | 13.199560 | 77.70688 | 0 |